EMT Practice Test

1. Question Content...

---

Question1: What is used to temporarily store the transaction logs of the source database before they are copied to the log?

Question2: How long is the default continuous recovery for the Gold SLA in Era Time Machine?

Question3: In an Oracle upgrade scenario using Era. if the source database is on a nor-Nutanix platform, is it possible to upgrade it with an Era workflow?

Question4: An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance.
Which step should the administrator take before applying the patch?

Question5: An administrator needs to distribute NDB management plane components.
Which NDB HA VM needs to be deployed on the same L2 network?

Question6: A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version.
What should the database admin do?

Question7: An administrator would like to replicate database snapshots to remote Nutanix clusters.
What should the administrator do to manage Time Machine data availability across all registered Nutanix clusters in NDB?

Question8: An administrator is trying to register a Nutanix cluster for Multi-Cluster provisioning.
The Era cluster is setup with following configuration:
* Era Multi-Cluster is enabled.
Era Server storage container and Era provisioning container are different on the Era cluster.
What should the administrator configure?

Question9: An administrator would like to provide a group of users the ability to add a new VLAN or IP Pool in Era.
What minimum role should the administrator assign to this group?

Question10: A development team has requested that an administrator provide them a copy of the production Finance database. The business requires that any financial data is masked before going into development.
How should the administrator create a clone with masked data for the development environment?

Question11: An administrator originally configured the storage for an Oracle database running on Nutanix NDB using ASMLib. The administrator would like to scale the size of the database.
What should the administrator do to most efficiently increase the size of the database?

Question12: An administrator needs to add a stretched VLAN across two clusters in NDB Which two prerequisites should be met prior to completing this action? (Choose two.)

Question13: Refer to the exhibit.

An administrator is receiving critical NDB email alerts regarding storage for the DBA database, which is a member of a database group.
How would the administrator remediate the issue within NDB?

Question14: What step should be taken to make the profile available to all users:

Question15: A quality assurance team noticed a significant change between a cloned database they are currently using versus the one used one week ago. They created an SQL script to verify the differences.
Which task should be performed by an NDB administrator to provide the correct database to the QA team?

Question16: An administrator enables NDB Multi-cluster.
Which NDB Service component is deployed on a dedicated VM?

Question17: What is required to create an NDB Software Profile?

Question18: An administrator wants to enable Multi-Cluster management on an Era installation.
Which prerequisites must be satisfied to complete this task?

Question19: Which two Oracle software components does Era patch? (Choose two.)

Question20: A NDB non-administrative user wants to provision an Oracle database leveraging a Software Profile that the administrator created. What must the administrator do to ensure that this user has access to the Oracle Software Profile?

Question21: How does NDB send notifications when alerts are generated?

Question22: How would an administrator enter the NDB command line to change the static IP address on the NDB VM?

Question23: When doing an Era software upgrade for a Multi-Cluster enabled installation, which component is upgraded first?

Question24:
An administrator tried to provision Nutanix Database Service (NDB) from Prism Central Marketplace and is getting the error shown in the exhibit.
Which action would have prevented this issue?

Question25: Which file format is available when downloading a list of alerts?

Question26: A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?

Question27: An administrator needs to work with databases and time machines, but not database parameter profiles.
Which role satisfies this requirement?

Question28: While registering an Always on Availability Group database, an administrator selects the following option:
Multiple Databases as a Group with One Time Machine
Which statement is true regarding this chosen option?

Question29: A legal team wants to audit a quarter end (July 31st) banking transaction event and asks the administrator to create a SQL database from the timeframe.
What action should the administrator perform within Era?

Question30: When running the Linux prerequisites script, an administrator discovers that the only required argument is -t.
What does the -t argument specify?

Question31: Where should an administrator perform an upgrade within the Era management interface?

Question32: How can NDB updates be downloaded for a dark site?

Question33: An administrator needs to provision multiple database clones from the same source database for different purposes, such as QA and Test/Development. To avoid resource starving, the administrator wants to differentiate VM resources for each department.
What is the most efficient way to accomplish this task?

Question34: An administrator wants to test the provisioning capabilities after a new NDB deployment. Which database instance would be available to accomplish this task?

Question35: Which statement describes what the Time Machine Heal function can be used for?

Question36: Why would an administrator want to publish a software profile update for Microsoft SQL Server that is created in NDB?

Question37: What behavior is observed when applying patch profiles as a Super Admin?

Question38: Why are ports 3205 and 3260 important when working with Era?

Question39: A database is de-registered without removing the associated Time Machine. What is the status of the Time Machine?

Question40: How should an administrator create a database clone using the Era IJI?

Question41: An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore time and minimize data loss.
What option should the administrator do to achieve this objective?

Question42: An administrator needs the ability to clone a source database to a point in time.
What is the lowest log frequency in minutes that can be configured in the Era IJI for log catchup operation?

Question43: A Log Catchup gap has occurred, impacting the ability to perform point-in-time restore (PITR) operations to create a clone or perform a database restore.
Which two statements below are true for the NDB Time Machine Heal Snapshot feature? (Choose two.)

Question44: Which two encryption methods can be used when configuring an SMTP server? (Choose two.)

Question45: Which response shows two ways to upgrade an NDB Server?

Question46: Which two processes should an administrator take to create a software profile version for a newly-released Oracle ISc patch? (Choose two.)

Question47: When the NDB upgrade includes updates to the out-of-the-box (OOB) software profiles, what happens to older OOB software profile versions when upgrading NDB?

Question48: An online retail application requires data to be synchronized between multiple SQL Server databases. This provides clearer reporting from multiple databases at the Same time for consistency at the end of each business day.
What is the best way to fulfill this requirement?

Question49: An administrator is trying to register a database server VM with NDB.
Which file types will prevent the registration from being successful if located in the C:\ drive?

Question50: An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?

Question51: In NDB, which two Time Machine options are available when creating a database clone? {Choose two.)

Question52: An administrator needs to restore databases provisioned with a shared disk configuration on Windows Storage Spaces What happens when NDB runs the restore operation?

Question53: An administrator needs to reset the NDB GUI password.
What should the administrator perform from the SSH session?

Question54: How can HA drivers for a Database VM be upgraded?

Question55: An administrator has noticed that the automatic snapshot and log catch-up (automatic and manual) activities for a Time Machine are halted and manual snapshots cannot be created.
What status is this Time Machine in?

Question56: An administrator has run into an error when provisioning a new Oracle database VM.
What is the best action that the administrator should perform in the NDB GUI to provide the most complete picture to send to Nutanix support on that specific operation?

Question57: An administrator enables NDB Multi-Cluster on Cluster A. Cluster B is then registered with NDB.
What are the different NDB Service VMs present in each Nutanix cluster?

Question58: Refer to the exhibit.

An administrator, whose accounts are shown in the exhibit, is trying to add a new database admin as a local user to NDB, but is unable to complete the task.
What is most likely the cause of the issue?

Question59: Before registering a SQL Server VM with NDB, an administrator must first verify what is enabled?

Question60: Refer to the exhibit.

An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.
Which database engine was being deployed during this operation?

Question61: For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?

Question62: An administrator has received a request to clone a source production database to an existing development server.
Which two actions must be taken to complete this task?

Question63: What are two status values that can be set within the Alerts Dashboard? (Choose two.)

Question64:
An administrator needs to restore a source database from a point in time at 21:50, but the restore option is not available.
What could explain the matter?

Question65: A database administrator is working with a cloned database and creates a clone removal schedule.
Which two default actions are taken on the cloned database? (Choose two.]

Question66: An administrator needs to change the maximum number of database connections during the cloning workflow.
Which Era profile should the administrator choose?

Question67: What must be completed within NDB before patching a Linux OS?

Question68: Which ports are used by the NDB database agent for API calls?

Question69: An administrator has been asked to patch several Nutanix database server VMs. Prior to patching, what should the administrator configure?

Question70: For supported Linux based database VM's managed by NDB, how would an administrator keep software profiles updated for provisioning new database VMs?

Question71: Which Time Machine feature allows developers to automate the data refresh for their clones?

Question72: A developer requests a new development database environment. The Era administrator identifies that there are insufficient resources on the development cluster.
Which two profiles should the administrator adjust to get the copy to fit within the resources available?
(Choose two.)

Question73: Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)

Question74: Which site needs to be reachable to ensure an NDB server can send periodic telemetry data to the central Nutanix repository over port 443?

Question75: An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:
* Two database server VMS including the primary replica on a local site
* A third database server VM on a remote site
How many IP addresses will the network at each site require?

Question76: An administrator has been tasked with OS and database patching in a Nutanix NDB environment. The administrator wishes to automate these activities.
What should the administrator configure to accomplish this task?

Question77: Which policies define Time Machine data availability across multiple registered clusters in NDB?

Question78: Refer to the exhibit.

A request is received to provision a new Oracle SIHA DB & VM to test ASMLIB on OEL79 and Oracle 19c.
When walking through the provisioning workflow, only ASMFD is available in the ASM Driver drop down.
What is necessary to provision the requested SIHA DB and DB VM with ASMLIB?

Question79: The NDB user interface can display which language option?

Question80: An administrator created a database clone that is scheduled for removal on the last day of the month.
A request has been received to keep the clone for an additional 14 days.
After selecting the desired clone, how should the administrator satisfy this task?

Question81: An administrator needs to deploy a database resilient cluster engine across three clusters. Which database engine can be used for this scenario?

Question82: An administrator needs to patch an Oracle Database Server VM and must ensure Grid home is allocated sufficient storage space.
At a minimum, how much space must be available for Grid home prior to completing this task?

Question83: An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?

Question84: A Linux OS is running a PostgreSQL instance that is managed by NDB. This instance is not working properly after a manual OS update, so an administrator has prepared a new Linux DB server VM that is ready to host the data from the broken DB.
Which action should the administrator perform to migrate data to the new DB server VM?

Question85: While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed

Question86: What is the purpose of Data Access Management policies in NDBMulti-Cluster?

Question87: An administrator is creating a Windows Domain profile in Era.
Which optional field can be skipped and provided during the provisioning process?

Question88: A vCenter instance which manages multiple clusters including a Nutanix cluster hosting NDB service crashed. After deploying a dedicated new vCenter server, the administrator needs to update vCenter setting within NDB.
Which action should be performed?

Question89: What is causing this issue?

Question90: Which file type must be downloaded from the Nutanix Portal for NDB deployment?

Question91: A developer with RBAC privileges in Era needs to refresh an existing DB Clone.
What steps must the developer take to perform the refresh?

Question92: An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.
How should the administrator best complete this task?

Question93: An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.
Which restore method is supported?

Question94: What is required to create an NDB Software Profile Version for PostgreSQL?

Question95: Where are two locations an administrator would find the size of a Source Database? (Choose two.)

Question96:
An administrator has opened the Enable Multi-Cluster configuration for an NDB instance, but the wizard does not present the VLAN, as shown in the exhibit.
Which configuration allows to choose a VLAN in the drop-down box?

Question97: What is the terminology used for registering an existing database with Era?

Question98: Which two security options are available when configuring an SMTP server for sending alert notifications via email? (Choose two.)

Question99: An administrator configures VM Host Affinity for database server VMs on a Nutanix AHV-powered cluster, intending to optimize HA by ensuring that VMs are placed on separate hosts. After a host failure, the administrator notices that database VMs are clustered on a single remaining host, risking another outage.
How could the administrator avoid this scenario in future host failures?

Question100: What must be completed within NDB before patching a Linux OS?

Question101: An administrator needs to register a SQL Server Single Node Database Server VM with NDB.
Which condition must exist prior to the administrator completing this task?

Question102: Which action must an administrator take in Era Networks before using Era to provision a MSSQL AG cluster?

Question103: Exhibit.

An administrator just created the ndb_test user as shown in the exhibit. Which two tasks can this user perform? (Choose two.)

Question104: An administrator needs to remove the default administrative account in use for NDB operations.
What is the recommended role for the Prism Element user to register a Nutanix cluster?

Question105: Which disk is omitted from a Software Profile?